#!bin/sh
source /etc/profile
day=$(date +%Y-%m-%d)
echo $day
yt=`date -d "1 days ago "  "+%Y-%m-%d"`
cd /home/marvin/sqoop-1.4.6-cdh5.6.0

#bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_oil --export-dir /user/hive/warehouse/res_oil/ --input-fields-terminated-by ',' -m 1
sh /home/marvin/daily_job/update/main/res_oil_main.sh

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_notoil --export-dir /user/hive/warehouse/res_notoil/ --input-fields-terminated-by ',' -m 1

#bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_notoilDepartment --export-dir /user/hive/warehouse/res_notoildepartment/ --input-fields-terminated-by ',' -m 1
sh /home/marvin/daily_job/update/main/res_notoilDepartment_main.sh
sh /home/marvin/daily_job/update/main/res_notoilDepartment_main.sh $day

#bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_notoilTop --export-dir /user/hive/warehouse/res_notoiltop/ --input-fields-terminated-by ',' -m 1
sh /home/marvin/daily_job/update/main/res_notoilTop_main.sh $yt
sh /home/marvin/daily_job/update/main/res_notoilTop_vip_main.sh $yt

#bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_lube --export-dir /user/hive/warehouse/res_lube/ --input-fields-terminated-by ',' -m 1  --input-null-string '\\N' --input-null-non-string '\\N'
sh /home/marvin/daily_job/update/main/res_lube_main.sh
sh /home/marvin/daily_job/update/main/res_lube_main.sh $day

#bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_notoilRate --export-dir /user/hive/warehouse/res_notoilrate/ --input-fields-terminated-by ',' -m 1
sh /home/marvin/daily_job/update/main/res_notoilRate_main.sh
sh /home/marvin/daily_job/update/main/res_notoilRate_main.sh $day

sh /home/marvin/daily_job/update/main/res_notoilRate_vip_main.sh
sh /home/marvin/daily_job/update/main/res_notoilRate_vip_main.sh $day

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_oilPrice --export-dir /user/hive/warehouse/res_oilprice/ --input-fields-terminated-by ',' -m 1

#bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_mop --export-dir /user/hive/warehouse/res_mop/ --input-fields-terminated-by ',' -m 1
sh /home/marvin/daily_job/update/main/res_mop_main.sh
sh /home/marvin/daily_job/update/main/res_mop_main.sh  $day

sh /home/marvin/daily_job/update/main/res_mop_vip_main.sh
sh /home/marvin/daily_job/update/main/res_mop_vip_main.sh $day

#bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_HHTIPT --export-dir /user/hive/warehouse/res_hhtipt/ --input-fields-terminated-by ',' -m 1
sh /home/marvin/daily_job/update/main/res_HHTIPT_main.sh
sh /home/marvin/daily_job/update/main/res_HHTIPT_main.sh $day

sh /home/marvin/daily_job/update/main/res_HHTIPT_vip_main.sh
sh /home/marvin/daily_job/update/main/res_HHTIPT_vip_main.sh $day

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_tr --export-dir /user/hive/warehouse/res_tr --input-fields-terminated-by ',' -m 1

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_mopipt --export-dir /user/hive/warehouse/res_mopipt/ --input-fields-terminated-by ',' -m 1

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_mophht --export-dir /user/hive/warehouse/res_mophht/ --input-fields-terminated-by ',' -m 1

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_exceptLube --export-dir /user/hive/warehouse/res_exceptlube/ --input-fields-terminated-by ',' -m 1







#bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_oil_vip --export-dir /user/hive/warehouse/res_oil_vip --input-fields-terminated-by ',' -m 1
sh /home/marvin/daily_job/update/main/res_oil_vip_main.sh
sh /home/marvin/daily_job/update/main/res_oil_vip_main.sh $day

#bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_notoil_vip --export-dir /user/hive/warehouse/res_notoil_vip --input-fields-terminated-by ',' -m 1
sh /home/marvin/daily_job/update/main/res_notoil_vip_main.sh

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_notoilDepartment_vip --export-dir /user/hive/warehouse/res_notoildepartment_vip/ --input-fields-terminated-by ',' -m 1

#bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_notoilTop_vip --export-dir /user/hive/warehouse/res_notoiltop_vip/ --input-fields-terminated-by ',' -m 1

#bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_lube_vip --export-dir /user/hive/warehouse/res_lube_vip/ --input-fields-terminated-by ',' -m 1
sh /home/marvin/daily_job/update/main/res_lube_vip_main.sh
sh /home/marvin/daily_job/update/main/res_lube_vip_main.sh $day

#bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_notoilRate_vip --export-dir /user/hive/warehouse/res_notoilrate_vip/ --input-fields-terminated-by ',' -m 1

#bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_mop_vip --export-dir /user/hive/warehouse/res_mop_vip/ --input-fields-terminated-by ',' -m 1

#bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_HHTIPT_vip --export-dir /user/hive/warehouse/res_hhtipt_vip/ --input-fields-terminated-by ',' -m 1

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_mopipt_vip --export-dir /user/hive/warehouse/res_mopipt_vip/ --input-fields-terminated-by ',' -m 1

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_mophht_vip --export-dir /user/hive/warehouse/res_mophht_vip/ --input-fields-terminated-by ',' -m 1

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_exceptLube_vip --export-dir /user/hive/warehouse/res_exceptlube_vip/ --input-fields-terminated-by ',' -m 1










bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_oilb --export-dir /user/hive/warehouse/res_oilb/ --input-fields-terminated-by ',' -m 1

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_mopb_vip --export-dir /user/hive/warehouse/res_mopb_vip/ --input-fields-terminated-by ',' -m 1 --input-null-string '\\N' --input-null-non-string '\\N' --fields-terminated-by '\t'

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_mopb --export-dir /user/hive/warehouse/res_mopb/ --input-fields-terminated-by ',' -m 1 --input-null-string '\\N' --input-null-non-string '\\N' --fields-terminated-by '\t'

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_mopiptb_vip --export-dir /user/hive/warehouse/res_mopiptb_vip/ --input-fields-terminated-by ',' -m 1 --input-null-string '\\N' --input-null-non-string '\\N' --fields-terminated-by '\t'

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_mopiptb --export-dir /user/hive/warehouse/res_mopiptb/ --input-fields-terminated-by ',' -m 1 --input-null-string '\\N' --input-null-non-string '\\N' --fields-terminated-by '\t'

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_mophhtb_vip --export-dir /user/hive/warehouse/res_mophhtb_vip/ --input-fields-terminated-by ',' -m 1 --input-null-string '\\N' --input-null-non-string '\\N' --fields-terminated-by '\t'

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_mophhtb --export-dir /user/hive/warehouse/res_mophhtb/ --input-fields-terminated-by ',' -m 1 --input-null-string '\\N' --input-null-non-string '\\N' --fields-terminated-by '\t'

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_notoilDepartmentb --export-dir /user/hive/warehouse/res_notoildepartmentb/ --input-fields-terminated-by ',' -m 1

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_notoilDepartmentb_vip --export-dir /user/hive/warehouse/res_notoildepartmentb_vip/ --input-fields-terminated-by ',' -m 1




#bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_addVip --export-dir /user/hive/warehouse/res_addvip/ --input-fields-terminated-by ',' -m 1
sh /home/marvin/daily_job/update/main/res_addVip_main.sh

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_vipChannel --export-dir /user/hive/warehouse/res_vipchannel/ --input-fields-terminated-by ',' -m 1

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_vipLiveness --export-dir /user/hive/warehouse/res_vipliveness/ --input-fields-terminated-by ',' -m 1

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_funnel --export-dir /user/hive/warehouse/res_funnel/ --input-fields-terminated-by ',' -m 1

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_vipFirstExpend --export-dir /user/hive/warehouse/res_vipfirstexpend/ --input-fields-terminated-by ',' -m 1

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_vipGap --export-dir /user/hive/warehouse/res_vipgap/ --input-fields-terminated-by ',' -m 1

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_vipDealMonth --export-dir /user/hive/warehouse/res_vipdealmonth/ --input-fields-terminated-by ',' -m 1

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_vipLastDeal --export-dir /user/hive/warehouse/res_viplastdeal/ --input-fields-terminated-by ',' -m 1

 bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_credits --export-dir /user/hive/warehouse/res_credits/ --input-fields-terminated-by ',' -m 1

 bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_creditsRate --export-dir /user/hive/warehouse/res_creditsrate/ --input-fields-terminated-by ',' -m 1

#bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_recharge --export-dir /user/hive/warehouse/res_recharge/ --input-fields-terminated-by ',' -m 1
sh /home/marvin/daily_job/update/main/res_recharge_main.sh

sh /home/marvin/daily_job/update/main/res_recharge_cd_main.sh

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_vipRechargeMonth --export-dir /user/hive/warehouse/res_viprechargemonth/ --input-fields-terminated-by ',' -m 1

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_vipLiveness_year --export-dir /user/hive/warehouse/res_vipliveness_year/ --input-fields-terminated-by ',' -m 1
bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_rechargeb --export-dir /user/hive/warehouse/res_rechargeb --input-fields-terminated-by ',' -m 1



#bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_addVip_cd --export-dir /user/hive/warehouse/res_addvip_cd/ --input-fields-terminated-by ',' -m 1
sh /home/marvin/daily_job/update/main/res_addVip_cd_main.sh

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_vipChannel_cd --export-dir /user/hive/warehouse/res_vipchannel_cd/ --input-fields-terminated-by ',' -m 1

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_vipLiveness_cd --export-dir /user/hive/warehouse/res_vipliveness_cd/ --input-fields-terminated-by ',' -m 1

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_funnel_cd --export-dir /user/hive/warehouse/res_funnel_cd/ --input-fields-terminated-by ',' -m 1

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_vipFirstExpend_cd --export-dir /user/hive/warehouse/res_vipfirstexpend_cd/ --input-fields-terminated-by ',' -m 1

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_vipGap_cd --export-dir /user/hive/warehouse/res_vipgap_cd/ --input-fields-terminated-by ',' -m 1

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_vipDealMonth_cd --export-dir /user/hive/warehouse/res_vipdealmonth_cd/ --input-fields-terminated-by ',' -m 1

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_vipLastDeal_cd --export-dir /user/hive/warehouse/res_viplastdeal_cd/ --input-fields-terminated-by ',' -m 1

#bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_recharge_cd --export-dir /user/hive/warehouse/res_recharge_cd/ --input-fields-terminated-by ',' -m 1

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_vipRechargeMonth_cd --export-dir /user/hive/warehouse/res_viprechargemonth_cd/ --input-fields-terminated-by ',' -m 1

 bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_credits_cd --export-dir /user/hive/warehouse/res_credits_cd/ --input-fields-terminated-by ',' -m 1

 bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_creditsRate_cd --export-dir /user/hive/warehouse/res_creditsrate_cd/ --input-fields-terminated-by ',' -m 1

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_vipLiveness_yearcd --export-dir /user/hive/warehouse/res_vipliveness_yearcd/ --input-fields-terminated-by ',' -m 1

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_rechargeb_cd --export-dir /user/hive/warehouse/res_rechargeb_cd --input-fields-terminated-by ',' -m 1

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_vipThirtyDaysRate --export-dir /user/hive/warehouse/res_vipthirtydaysrate/ --input-fields-terminated-by ',' -m 1

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_vipDrain --export-dir /user/hive/warehouse/res_vipdrain/ --input-fields-terminated-by ',' -m 1

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_vipSixtyDaysRate --export-dir /user/hive/warehouse/res_vipsixtydaysrate/ --input-fields-terminated-by ',' -m 1

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_vipSixtyDaysRate_cd --export-dir /user/hive/warehouse/res_vipsixtydaysrate_cd/ --input-fields-terminated-by ',' -m 1

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_vipDrain_cd --export-dir /user/hive/warehouse/res_vipdrain_cd/ --input-fields-terminated-by ',' -m 1

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_vipThirtyDaysRate_cd --export-dir /user/hive/warehouse/res_vipthirtydaysrate_cd/ --input-fields-terminated-by ',' -m 1

#bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_vipEvaluation_all --export-dir /user/hive/warehouse/res_vipevaluation_all/ --input-fields-terminated-by ',' -m 1
sh /home/marvin/daily_job/update/main/res_vipEvaluation_all_main.sh

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_vipEvaluationb_all --export-dir /user/hive/warehouse/res_vipevaluationb_all/ --input-fields-terminated-by ',' -m 1

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_vipLiveNess_stationall --export-dir /user/hive/warehouse/res_vipliveness_stationall/ --input-fields-terminated-by ',' -m 1



bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_wechatmall_top --export-dir /user/hive/warehouse/res_wechatmall_top/ --input-fields-terminated-by ',' -m 1 --input-null-string '\\N' --input-null-non-string '\\N' --fields-terminated-by '\t'

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_wechatmall_status --export-dir /user/hive/warehouse/res_wechatmall_status/ --input-fields-terminated-by ',' -m 1 --input-null-string '\\N' --input-null-non-string '\\N' --fields-terminated-by '\t'

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_vipcoupon_ladder --export-dir /user/hive/warehouse/res_vipcoupon_ladder --input-fields-terminated-by ',' -m 1

#bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_vipcouponbb --export-dir /user/hive/warehouse/res_vipcouponbb --input-fields-terminated-by ',' -m 1

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_vipCoupon --export-dir /user/hive/warehouse/res_vipcoupon/ --input-fields-terminated-by ',' -m 1

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_vipCouponRate --export-dir /user/hive/warehouse/res_vipcouponrate/ --input-fields-terminated-by ',' -m 1

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_couponTactic --export-dir /user/hive/warehouse/res_coupontactic/ --input-fields-terminated-by ',' -m 1 

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_vipcoupon_station --export-dir /user/hive/warehouse/res_vipcoupon_station/ --input-fields-terminated-by ',' -m 1  --input-null-string '\\N' --input-null-non-string '\\N'





bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_hoseEfficiency --export-dir /user/hive/warehouse/res_hoseefficiency --input-fields-terminated-by ',' -m 1 --input-null-string '\\N' --input-null-non-string '\\N' --fields-terminated-by '\t'


bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table comparison_hiveb --export-dir /user/hive/warehouse/comparison_hiveb --input-fields-terminated-by ',' -m 1 --input-null-string '\\N' --input-null-non-string '\\N' --fields-terminated-by '\t'






bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table basket_bj --export-dir /user/hive/warehouse/basket_bj/ --input-fields-terminated-by ',' -m 1

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table basket_cd --export-dir /user/hive/warehouse/basket_cd/ --input-fields-terminated-by ',' -m 1

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table basket_all --export-dir /user/hive/warehouse/basket_all/ --input-fields-terminated-by ',' -m 1

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table RFM --export-dir /user/hive/warehouse/rfm/ --input-fields-terminated-by ',' -m 1 --input-null-string '\\N' --input-null-non-string '\\N' --fields-terminated-by '\t'

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table RFM_cd --export-dir /user/hive/warehouse/rfm_cd/ --input-fields-terminated-by ',' -m 1 --input-null-string '\\N' --input-null-non-string '\\N' --fields-terminated-by '\t'




bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_notoilSearch --export-dir /user/hive/warehouse/res_notoilsearch/ --input-fields-terminated-by ',' -m 1 

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table tag_result --export-dir /user/hive/warehouse/tag_result/ --input-fields-terminated-by ',' -m 1 --input-null-string '\\N' --input-null-non-string '\\N' --fields-terminated-by '\t'


#bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_vipcouponbbb --export-dir /user/hive/warehouse/res_vipcouponbbb/ --input-fields-terminated-by ',' -m 1

#bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_vipcouponbbb_oil --export-dir /user/hive/warehouse/res_vipcouponbbb_oil/ --input-fields-terminated-by ',' -m 1

#bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_vipcouponbbb_notoil --export-dir /user/hive/warehouse/res_vipcouponbbb_notoil/ --input-fields-terminated-by ',' -m 1

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_wechatmall_topall --export-dir /user/hive/warehouse/res_wechatmall_topall/ --input-fields-terminated-by ',' -m 1 --input-null-string '\\N' --input-null-non-string '\\N' --fields-terminated-by '\t'

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_evaluation --export-dir /user/hive/warehouse/res_evaluation/ --input-fields-terminated-by ',' -m 1

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table tag_result_thirty --export-dir /user/hive/warehouse/tag_result_thirty/ --input-fields-terminated-by ',' -m 1 --input-null-string '\\N' --input-null-non-string '\\N' --fields-terminated-by '\t'

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table tag_result_sixty --export-dir /user/hive/warehouse/tag_result_sixty/ --input-fields-terminated-by ',' -m 1 --input-null-string '\\N' --input-null-non-string '\\N' --fields-terminated-by '\t'

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table tag_result_ninety --export-dir /user/hive/warehouse/tag_result_ninety/ --input-fields-terminated-by ',' -m 1 --input-null-string '\\N' --input-null-non-string '\\N' --fields-terminated-by '\t'

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table tag_result_thirty_cd --export-dir /user/hive/warehouse/tag_result_thirty_cd/ --input-fields-terminated-by ',' -m 1 --input-null-string '\\N' --input-null-non-string '\\N' --fields-terminated-by '\t'

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table tag_result_sixty_cd --export-dir /user/hive/warehouse/tag_result_sixty_cd/ --input-fields-terminated-by ',' -m 1 --input-null-string '\\N' --input-null-non-string '\\N' --fields-terminated-by '\t'

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table tag_result_ninety_cd --export-dir /user/hive/warehouse/tag_result_ninety_cd/ --input-fields-terminated-by ',' -m 1 --input-null-string '\\N' --input-null-non-string '\\N' --fields-terminated-by '\t'

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table tag_result_cd --export-dir /user/hive/warehouse/tag_result_cd/ --input-fields-terminated-by ',' -m 1 --input-null-string '\\N' --input-null-non-string '\\N' --fields-terminated-by '\t'



bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_coupon --export-dir /user/hive/warehouse/res_coupon/ --input-fields-terminated-by ',' -m 1 --input-null-string '\\N' --input-null-non-string '\\N' --fields-terminated-by '\t'

#bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_vipcoupon_score --export-dir /user/hive/warehouse/res_vipcoupon_score/ --input-fields-terminated-by ',' -m 1 --input-null-string '\\N' --input-null-non-string '\\N' --fields-terminated-by '\t'

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_coupon_send --export-dir /user/hive/warehouse/res_coupon_send/ --input-fields-terminated-by ',' -m 1 --input-null-string '\\N' --input-null-non-string '\\N' --fields-terminated-by '\t'


bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_vipcoupon_source --export-dir /user/hive/warehouse/res_vipcoupon_source/ --input-fields-terminated-by ',' -m 1 --input-null-string '\\N' --input-null-non-string '\\N' --fields-terminated-by '\t'

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_vipcoupon_oilnotoil --export-dir /user/hive/warehouse/res_vipcoupon_oilnotoil/ --input-fields-terminated-by ',' -m 1 --input-null-string '\\N' --input-null-non-string '\\N' --fields-terminated-by '\t'

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_vipcoupon_nature --export-dir /user/hive/warehouse/res_vipcoupon_nature/ --input-fields-terminated-by ',' -m 1 --input-null-string '\\N' --input-null-non-string '\\N' --fields-terminated-by '\t'

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_vipcoupon_discsource --export-dir /user/hive/warehouse/res_vipcoupon_discsource/ --input-fields-terminated-by ',' -m 1 --input-null-string '\\N' --input-null-non-string '\\N' --fields-terminated-by '\t'



bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_oilb_vip --export-dir /user/hive/warehouse/res_oilb_vip --input-fields-terminated-by ',' -m 1

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table tag_result_alltime --export-dir /user/hive/warehouse/tag_result_alltime/ --input-fields-terminated-by ',' -m 1 --input-null-string '\\N' --input-null-non-string '\\N' --fields-terminated-by '\t'

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table tag_result_alltimecd --export-dir /user/hive/warehouse/tag_result_alltimecd/ --input-fields-terminated-by ',' -m 1 --input-null-string '\\N' --input-null-non-string '\\N' --fields-terminated-by '\t'

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_notoilSearch_vip --export-dir /user/hive/warehouse/res_notoilsearch_vip/ --input-fields-terminated-by ',' -m 1 

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_openingdate --export-dir /user/hive/warehouse/res_openingdate/ --input-fields-terminated-by ',' -m 1 

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table vip_item --export-dir /user/hive/warehouse/vip_item/ --input-fields-terminated-by ',' -m 1 --input-null-string '\\N' --input-null-non-string '\\N' --fields-terminated-by '\t'

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table vip_interval_cd --export-dir /user/hive/warehouse/vip_interval_cd/ --input-fields-terminated-by ',' -m 1 --input-null-string '\\N' --input-null-non-string '\\N' --fields-terminated-by '\t'

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table vip_interval --export-dir /user/hive/warehouse/vip_interval/ --input-fields-terminated-by ',' -m 1 --input-null-string '\\N' --input-null-non-string '\\N' --fields-terminated-by '\t'

bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table vip_coupon --export-dir /user/hive/warehouse/vip_coupon/ --input-fields-terminated-by ',' -m 1 --input-null-string '\\N' --input-null-non-string '\\N' --fields-terminated-by '\t'

#bin/sqoop export --connect jdbc:mysql://192.168.0.34:3306/result --username root --password root --table res_coupon_sum --export-dir /user/hive/warehouse/res_coupon_sum/dt=$yt --input-fields-terminated-by ',' -m 1
sh /home/marvin/daily_job/mysql/coupon/all.sh